// var mysql      = require('mysql');
// var connection = mysql.createConnection({
//   host     : 'localhost',
//   user     : 'root',
//   password : '',
//   database : 'juzao'
// });
 

// connection.connect();
// module.exports = (sql) => {
//   return new Promise(next => {
//     // connection.connect();
//     connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
//     if (error) throw error;
//     // console.log('The solution is: ', results[0].solution);
//     next(results)
//   });
//     // connection.end();
//   })
// }




var mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'localhost',
    port: 3306,
    user: 'root',
    password: '',
    database: 'juzao',
    multipleStatements:true
});
connection.connect();
module.exports = (sql) => {
    return new Promise(next => {
        
        connection.query(sql, function (error, results, fields) {
            if(error) throw error;
            //console.log('The solution is:', results[0].solution);
            next(results)
        });
        // connection.end();
    })
}